package com.kenobi.visualData;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper {

	public DBHelper(Context context){
		super(context, "kenobi.db", null, 1);
	}
	
	@Override
	public void onCreate(SQLiteDatabase database) {
		String strCreateSQL = "CREATE TABLE visualData (visualDataID INTEGER PRIMARY KEY AUTOINCREMENT" +
				", musicID INTEGER NOT NULL" +
				", title TEXT NULL" +
				", imgURL TEXT NOT NULL" +
				", articleLink TEXT NULL" + 
				", filePath TEXT NULL);";
		database.execSQL(strCreateSQL);
	}

	@Override
	public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
		
	}

}
